UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oC1CuLIiXbnk7isNuTGdBpb6r4X8EDNCTE1ZchnKCfE='
WHERE
key_id = '2acae737dc4537917daf9226a350f3d479de4251cd4aa25886ccde022a26196e'
AND (
token = 'oC1CuLIiXbnk7isNuTGdBpb6r4X8EDNCTE1ZchnKCfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)