UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+0aFbhhBlXqDy8Aefy5s8gS5Zz6NM+LVPxxFjt7ByOk=' 
WHERE 
  key_id = 'e296d2bcb89564b9b09d85a59d6ecd857926a7bba40313704935205235e6e7d4' 
  AND (
    token = '+0aFbhhBlXqDy8Aefy5s8gS5Zz6NM+LVPxxFjt7ByOk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022