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