UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z0C7M7U2ehnToX41xz5gwGBb9dIemx9VViZALQZ2M4Y='
WHERE
key_id = 'd7e4b2e80ae5f608f1e25d8075de69096ca2a774bfb722b0b6b7eb2aa4b3ef91'
AND (
token = 'Z0C7M7U2ehnToX41xz5gwGBb9dIemx9VViZALQZ2M4Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)