UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'P9M/RirlNk+xLyGj/Rh/i8EhS71xsjVqIVdtEs7pIMk=' 
WHERE 
  key_id = '36d9adebc74cc009b84defabeb3f5ab7d168c65509d2b4e4da4abc989bedcae8' 
  AND (
    token = 'P9M/RirlNk+xLyGj/Rh/i8EhS71xsjVqIVdtEs7pIMk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030