UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'cO1rwWyyXvY6RYP61A25r9Uz1I7hdyo9DbKVp7gt2pY=' 
WHERE 
  key_id = 'c182cb6ea8bf678e3df7ccf6fb2e7703b5db0c8f80aa4af5b74a8d9647167bee' 
  AND (
    token = 'cO1rwWyyXvY6RYP61A25r9Uz1I7hdyo9DbKVp7gt2pY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00056