UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qmjABe3cAR1LAzbd4UZjxZrZtsyZ/ssgWkgsee28SVY='
WHERE
key_id = '18d302766a3f90e3649a5ec376622f233c16ae1464cb87237c5e0ed7042f3274'
AND (
token = 'qmjABe3cAR1LAzbd4UZjxZrZtsyZ/ssgWkgsee28SVY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)