UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4QaPXriTD1qfi0xrVqQBgLhMp0LPE47s9znpCMKWrhA='
WHERE
key_id = '312c6f2f144fa39a708254ade96c6580690664173a7ccbba220199a448d04a2c'
AND (
token = '4QaPXriTD1qfi0xrVqQBgLhMp0LPE47s9znpCMKWrhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)