UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HLaK7LuqTPNYRcUp/h06cXaEF7gOdbZ+TpKV3Q2YWno='
WHERE
key_id = '84575b3498e077531e48fa6f6479367978c7c14ae2d7e0d05d4ae693a0ea6110'
AND (
token = 'HLaK7LuqTPNYRcUp/h06cXaEF7gOdbZ+TpKV3Q2YWno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)