UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'KcxEJ2JcS4BaGMEt2a3Lk6S6tqC68peXgGfDzc+kJ90=' 
WHERE 
  key_id = '0638ab185332e35b45156290a6e426039a9dc6ad1be787afbe03cd23d12d87b7' 
  AND (
    token = 'KcxEJ2JcS4BaGMEt2a3Lk6S6tqC68peXgGfDzc+kJ90=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027