UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'P/XxnscU+GJnZliV0O+gMPkTfQOW+Ep9fhcglKdLmF0=' 
WHERE 
  key_id = '0f2cdd4b78126bdd020a54130fc48df38bc62de784d290e2634f03805c46e42f' 
  AND (
    token = 'P/XxnscU+GJnZliV0O+gMPkTfQOW+Ep9fhcglKdLmF0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018