UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9LE6e/+Ad+jmRXnfrvdaL2Ulnp6rb7GT1NnOC+L1NZE='
WHERE
key_id = 'cad42f04196b9df98979447051819560ddb841ef053141d700c6283ccfde186e'
AND (
token = '9LE6e/+Ad+jmRXnfrvdaL2Ulnp6rb7GT1NnOC+L1NZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)