UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LfBgHJJ5JMkw6psjXzWKKJLIJlSuLCy6hlZhO5zwnAQ='
WHERE
key_id = 'e3de6b3c9fd819801338a36d6b651e9f6212c7becce7c08a9a7bc6dcc5be057e'
AND (
token = 'LfBgHJJ5JMkw6psjXzWKKJLIJlSuLCy6hlZhO5zwnAQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)