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