UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RlU4yA/9nOD9Cn+EY1m2AsV6Pv2rtFrIuHvK49p7hPA='
WHERE
key_id = 'c723aa6559fd836052a8078c3bc2fcd6d57fa9302b318cbd2522118d3314eb16'
AND (
token = 'RlU4yA/9nOD9Cn+EY1m2AsV6Pv2rtFrIuHvK49p7hPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)