UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nZZWeu6AnVuKECKojbPNMFVaSXfqGk5f7bSajuDQWfM='
WHERE
key_id = '28c500bab36bf6548a978710f89a68dc58790c5937af4a52c263c3d42371d225'
AND (
token = 'nZZWeu6AnVuKECKojbPNMFVaSXfqGk5f7bSajuDQWfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)