UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WejYEj8fXXG0nxQ4g8QWxVQMKhFak+kmH78Sius64Nw='
WHERE
key_id = '26094e7e144d47d61d0520fdb68968bfd30a331e7ec7ffd06fe57a98244cc0e5'
AND (
token = 'WejYEj8fXXG0nxQ4g8QWxVQMKhFak+kmH78Sius64Nw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)