UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6tErg964j+c7CyUzq9e6l6xEIZ1u0M0u1i9GNZEnhUE=' 
WHERE 
  key_id = 'd94640482f1c0aa9b1b40a7c22dce3738bfeff3f27d601477e54e1f32a2f5951' 
  AND (
    token = '6tErg964j+c7CyUzq9e6l6xEIZ1u0M0u1i9GNZEnhUE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023