UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'K4//25RivqGt5bb4h8dD75HfOubCK68WcwXlSnsfH/A=' 
WHERE 
  key_id = '41a22b8512cc34d9c21914725e89ddf8848271011cd2f5151843452bc51c4e5d' 
  AND (
    token = 'K4//25RivqGt5bb4h8dD75HfOubCK68WcwXlSnsfH/A=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031