UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6LGSqbzkhDLViOn8FsDG1ItRKnwU5aK2bmoAcuE615s='
WHERE
key_id = '265112c2b780df9e30b3b1b16666c7bf16d699c2a97aeeb739358282ce90258d'
AND (
token = '6LGSqbzkhDLViOn8FsDG1ItRKnwU5aK2bmoAcuE615s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)