UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'aLBapH91PX1Gr3hDKiTBQm1EopN+nvsr+8TbuuilTkE=' 
WHERE 
  key_id = '69693e8ad3a093e9090ab3644ac623c31fc7cc3333f4091d565f61041206c4f4' 
  AND (
    token = 'aLBapH91PX1Gr3hDKiTBQm1EopN+nvsr+8TbuuilTkE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021