UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1PNn6TXqkINw1hAeWYm2t6lHMBDIyEedM+WUN/PRjhw='
WHERE
key_id = '18015e65c700e6ebae9b34ba6a648fa4aae897638c4cf7201263ce12228497e4'
AND (
token = '1PNn6TXqkINw1hAeWYm2t6lHMBDIyEedM+WUN/PRjhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)