UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'glyVTQ06LcA8D6g9LZtImSc5sL/v2eWFiAe1xj44EiU='
WHERE
key_id = 'c78655eaf9e2c1309b64cb41d4284679f865fdee2118a3bc97ab50f888593428'
AND (
token = 'glyVTQ06LcA8D6g9LZtImSc5sL/v2eWFiAe1xj44EiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)