UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J/hDsZ8ELjG7OIwa1fxV3wQzOKZNhUGaP8ExO+g5y4Q='
WHERE
key_id = 'ca30130d7a73ed71c8117efde719b339049983b070100f81998a594c6fde1171'
AND (
token = 'J/hDsZ8ELjG7OIwa1fxV3wQzOKZNhUGaP8ExO+g5y4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)