UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BK/ye4wDQApzHJEFWl2MQtRT1p12fF/DraYAR23nwx8='
WHERE
key_id = '849271522e078659b7eea5ebc0c05adcb76e8d09dd9f431e37fa65783c551e2b'
AND (
token = 'BK/ye4wDQApzHJEFWl2MQtRT1p12fF/DraYAR23nwx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)