UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'YnjWYTMV7S9FHi86vWA1V6t4+eSsLT8gh70Yz7gwTZc=' 
WHERE 
  key_id = '8e0851cd85d5303e18e247882e189918d7b38a4820aca429ba5c4d18cd9c9396' 
  AND (
    token = 'YnjWYTMV7S9FHi86vWA1V6t4+eSsLT8gh70Yz7gwTZc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027