UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qaA2cWoJVP1sDZSLVPpdlI0z7E+Qix6Z5GQo3SpcwkY='
WHERE
key_id = '2c57f4ddfbf82d8970a20b195a6e34f14c865663bbb5f73f17119adb31ceb138'
AND (
token = 'qaA2cWoJVP1sDZSLVPpdlI0z7E+Qix6Z5GQo3SpcwkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)