UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VhJAPfbD+RqC9w9yDfiZ/3OKGORaUxwBz9FRlZiYAuk='
WHERE
key_id = '5967685c9f2f35168f1a78fcb8100a1403a31f04fdbe53bd01f0995f1fb35298'
AND (
token = 'VhJAPfbD+RqC9w9yDfiZ/3OKGORaUxwBz9FRlZiYAuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)