UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lweEtJ7J+nTaIRAJ6wt+pOBznFMhTfriIXnqakqD+lo='
WHERE
key_id = 'ce1f048ebdd396e0995a6c04d2f7795d1e1bc09769d8c799d6d6f3ca0dea09ba'
AND (
token = 'lweEtJ7J+nTaIRAJ6wt+pOBznFMhTfriIXnqakqD+lo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)