UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tPfTxR1JHAML1TweBUc5eyXgqpgOPg1I+BBQy2xuzoM=' 
WHERE 
  key_id = '640b761745357fb5a6e8532d9b515a6a1c71976e0e5794d241112d348abd71bf' 
  AND (
    token = 'tPfTxR1JHAML1TweBUc5eyXgqpgOPg1I+BBQy2xuzoM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033