UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'phAAnSM+XZZ+SB/6QMIK2H1EY8lGaGcZKvy4kdVprZE=' 
WHERE 
  key_id = 'c9ef407a792ee3281f03c593f5a1af9fd9bf5b79a49b9c0531c15257cd372356' 
  AND (
    token = 'phAAnSM+XZZ+SB/6QMIK2H1EY8lGaGcZKvy4kdVprZE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029