UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vU6bNCIwL3l1ot5w3mAZu6FKaytJTqLzXFIH6WFr/6s='
WHERE
key_id = '3c97c99261b2ccfd8343b4e678c79414cbbd29848809a47c95332190d900273f'
AND (
token = 'vU6bNCIwL3l1ot5w3mAZu6FKaytJTqLzXFIH6WFr/6s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)