UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'E47hpT9ziM+MZ549Jn82GGsqkTKY5ZiLEyY5VG+oTVY=' 
WHERE 
  key_id = '54939a78aa08934c1c4688653fbb5a0b625b1add4a1c24204471a59cc11378c3' 
  AND (
    token = 'E47hpT9ziM+MZ549Jn82GGsqkTKY5ZiLEyY5VG+oTVY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045