UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B7Ocf+nnQ7vYt1tuP9SfZdAFypWhGDDOa5bhCUonoIw='
WHERE
key_id = '8a943bc877296da0d058422ef9b3582aa88ec82ef9e989be2768fa29a1ec6025'
AND (
token = 'B7Ocf+nnQ7vYt1tuP9SfZdAFypWhGDDOa5bhCUonoIw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)