UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zFYU0GiKg02S04zr1vZucwryPisOn7NG98V2ZoSRn8A='
WHERE
key_id = '885eee5caf35c5ad3d0d26079537c7916589699d6dd94b8a800da923f5b3d2ed'
AND (
token = 'zFYU0GiKg02S04zr1vZucwryPisOn7NG98V2ZoSRn8A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)