UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'by+PZ0A5sz/3AUxlUU+JpEoIolXcjITGHLbI+rBDPNA=' 
WHERE 
  key_id = '56b3a347a7b182b6887a03594b30755f81ac32813bee78d70b8b35aec0d4f83c' 
  AND (
    token = 'by+PZ0A5sz/3AUxlUU+JpEoIolXcjITGHLbI+rBDPNA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034