UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XVJkv3XrqNZORbS1SwivLQ3ZH2b4hk2z4o9qfWFzTik='
WHERE
key_id = '0c3b5c05135935d73b5646e52aded45908d17667860061a2f4e3550e527b047a'
AND (
token = 'XVJkv3XrqNZORbS1SwivLQ3ZH2b4hk2z4o9qfWFzTik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)