UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CcP45QKs31VgnEaL1taJs059lYvRd/S/m6kyWW4EiqE='
WHERE
key_id = 'e052fae796a6e94e39584ff390888d8a8f009785b04f7427d0a581c37174a08e'
AND (
token = 'CcP45QKs31VgnEaL1taJs059lYvRd/S/m6kyWW4EiqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)