UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P6OSsbigV7t5ZJH4YwpdpmBDhNn+av9t+LsDUh/fSdk='
WHERE
key_id = 'e198f6cefc9e0b5ce399cadeeab96211ea461ce8ea10cbc86201e4b9bb0969f8'
AND (
token = 'P6OSsbigV7t5ZJH4YwpdpmBDhNn+av9t+LsDUh/fSdk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)