UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cm1m+ooJS3GVLvbldYIozGsyAZR1fjt9JSKFHgw47W8='
WHERE
key_id = '12aa5c64c63d5636f95869acac99cf7a239db201fe62ee85c158d1dbbc74a74b'
AND (
token = 'cm1m+ooJS3GVLvbldYIozGsyAZR1fjt9JSKFHgw47W8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)