UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XYMml//WlfLLrlVQ0FieLnVoNpux+GATPf5axUN0KWI='
WHERE
key_id = 'cd4ad324a504f58b366d10c8c07f4e9ec791b50bdfb27b9863fdbcd83d74ceae'
AND (
token = 'XYMml//WlfLLrlVQ0FieLnVoNpux+GATPf5axUN0KWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)