UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LEGXyzJbczMSRnGOG7hqpO+mfJka6hp5vh1GgW2uby4='
WHERE
key_id = '7d2f90f24c6ed68d7792314c813d903d1fe1b6c03ab08bef04765dd55b70aa92'
AND (
token = 'LEGXyzJbczMSRnGOG7hqpO+mfJka6hp5vh1GgW2uby4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)