UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fQmuwkIfSxAmhP/COvzkcIC/vIIhbx7Kmg02+xSvaaQ='
WHERE
key_id = 'fadc8a0b744f24a7f1693974bf14ef053d3cd453146aa35d9d02d523edc18c21'
AND (
token = 'fQmuwkIfSxAmhP/COvzkcIC/vIIhbx7Kmg02+xSvaaQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)