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